home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Fritz: All Fritz
/
All Fritz.zip
/
All Fritz
/
FILES
/
BUSINESS
/
DAYOKISB.LZH
/
KISBSW.EXE
/
KISBILL.DOC
< prev
next >
Wrap
Text File
|
1992-05-23
|
261KB
|
3,244 lines
╔════════════════════════════════════════════════════════════════════════════╗
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░ ▓░░░ ▓░░ ▓░░ ▓░░ ▓░░ ▓░░ ▓░░░░░░ ▓░░░░░░░░░║
║░░░░░░░ ▓░░░ ▓░░░ ▓░░░ ▓░░░░░░░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║
║░░░░░░░ ▓░░░ ▓░░░ ▓░░░ ▓░░░░░░░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║
║░░░░░░░ ▓░░ ▓░░░░ ▓░░░ ▓░░░░░░░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║
║░░░░░░░ ▓░ ▓░░░░░ ▓░░░ ▓░░░░░░░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║
║░░░░░░░ ▓░░░░░░ ▓░░░ ▓░░ ▓░░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║
║░░░░░░░ ▓░░░░░░ ▓░░░░░░░░░ ▓░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║
║░░░░░░░ ▓░ ▓░░░░░ ▓░░░░░░░░░ ▓░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║
║░░░░░░░ ▓░ ▓░░░░░ ▓░░░░░░░░░ ▓░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║
║░░░░░░░ ▓░░ ▓░░░░ ▓░░░░░░░░░ ▓░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║
║░░░░░░░ ▓░░░ ▓░░ ▓░░ ▓░░ ▓░░ ▓░░ ▓░░ ▓░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
╠════════════════════════════════════════════════════════════════════════════╣
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░ Version 4.01 (21 May 1992) ░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░ Keep It Simple Billing & Invoicing System ░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║
╠════════════════════════════════════════════════════════════════════════════╣
║ Copyright (c) 1987-1992, TJS LAB Inc. ║
║ 5104 North Orange Blossom Trail, Ste 200, Orlando, FL 32810 ║
║ ║
║ ██████ ▀███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ S H N ║
║ ▀ ██ ▀ ████ ▀▀▀▀▀███████████████████████████▌ O A E ║
║ ██ ██ ▄███▄ ▀████▀▀ ▀████████████ F R T ║
║ ██ ██ ██ ▀ ▀▀ ███████████ T D W ║
║ ██ ▄ ██ ▀███▄ Specializing In ▐█████████▌ W W O ║
║ ▀███▀ ▄ ██ MicroComputer & Network ██████████ A A R ║
║ ▀███▀ Solutions & █████*████▌ R R K ║
║ Applications ▐███████████ E E S ║
║ ▀██ █ ▀█▄███▄ ┌─┐ ┌─┐ ███████████▌ ║
║ ██ █▀█ ██ ██ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ Custom: ║
║ ██ ▄█ █▄ █████ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ Programs ║
║ ██ ██▄██ ██ ██ ▐▀▌ └───╜ ▐▀▌ ███▄▄███ Reports ║
║ ████ ▄█ █▄ █▀███▀ █████ ▐▀▌ █████ ▀█████▌ Routines ║
║ █████ ▀▀▀█ Forms ║
║ Incorporated █ ║
║ ▄▄▄▄▀ ║
╠════════════════════════════════════════════════════════════════════════════╣
║ Support: (407) 291-3960 Sales: 292-4708 Fax: 295-2171 BBS: 292-4921 ║
╚════════════════════════════════════════════════════════════════════════════╝
KISBILL - Keep It Simple Billing and Invoicing System
■ SOFTWARE SUPPORT POLICY
1. TJS LAB does not support users of unregistered products with the
exception of installation questions.
2. Support (included with registration) remains in effect for 3 months
after date of registration or purchase.
3. Support is available through the following methods:
- Phone/Voice Mail: (407) 291-3960 or 292-4708
- BBS: (407) 292-4921 (8-N-1) 2400-9600
- U.S. Mail: TJS LAB, PO Box 585366, Orlando, FL 32858-5366
- Compuserve Easyplex: 76367,1401
4. Any errors ("bugs or features') in the program will be corrected and
the 'fix' sent promptly (via modem if possible).
KISBILL - Keep It Simple Billing and Invoicing System
Table of Contents
Page Subject
──── ───────────────────────────────────────
1 ................ INTRODUCTION
2 ................ COPYRIGHT/LICENSE
2 ................ DISCLAIMER
2 ................ REQUIREMENTS
2 ................ SETUP
3 ................ MAIN MENU
3 ................ EXIT TO DOS
4 ................ BROWSE, CREATE, MAINTAIN INVOICES
5 ................ INVOICE HEADER FULL SCREEN EDIT - F2
5 ................ BROWSE THE DETAIL RECORDS - F3
6 ................ DETAIL FULL SCREEN EDIT - F2
6 ................ FIND INVOICE NUMBER
6 ................ FIND ITEM NUMBER
6 ................ FIND ITEM DESCRIPTION
7 ................ PRINT/REPRINT INVOICE - F4
8 ................ EXAMPLE OF THE STANDARD INVOICE
9 ................ ADD/CREATE INVOICE - CTRL N
10 ................ ADDING DETAIL ITEMS TO INVOICE
11 ................ SELECT ITEM FROM PAST SALES - F3
11 ................ MANUALLY ADD ITEM - CTRL N
12 ................ DELETE INVOICE - CTRL U
12 ................ RECALCULATE INVOICE SUBTOTAL - CTRL F1
12 ................ FIND INVOICE
12 ................ FIND CUSTOMER NAME
12 ................ FIND CUSTOMER NUMBER
13 ................ FIND CUSTOMER'S PHONE NUMBER
13 ................ FIND CUSTOMER PURCHASE ORDER NUMBER
13.1 ............... PRINT STATEMENT - ALT S
13.1 ............... STATEMENT EXAMPLE
14 ................ REPORTS
14 ................ REPORTS FORMS
14 ................ REPORTS LISTING
15 ................ HEADER INVOICE REPORT
16 ................ DETAIL INVOICE REPORT
16 ................ EXAMPLE OF THE DETAIL INVOICE REPORT
16 ................ PRODUCT/ITEM LISTING
17 ................ EXAMPLE OF THE PRODUCT/ITEM REPORT
17 ................ DETAIL PRODUCT/ITEM MOVEMENT REPORT
17 ................ EXAMPLE OF THE PRODUCT/ITEM MOVEMENT REPORT
18 ................ CUSTOMERS LIST
18 ................ EXAMPLE OF THE CUSTOMERS LIST
19 ................ ADDRESS & MAILING LABELS
KISBILL - Keep It Simple Billing and Invoicing System
Table of Contents
Page Subject
──── ───────────────────────────────────────
19 ................ EXAMPLE OF ADDRESS/MAILING LABELS
20 ................ FOLDER LABELS
20 ................ EXAMPLE OF A FOLDER LABEL
20 ................ OPEN INVOICE REPORT
21 ................ SALES GRAPH
21 ................ GRAPH EXAMPLE #1
22 ................ GRAPH EXAMPLE #2
23 ................ CONFIGURATION
23 ................ CONFIGURATION SETTINGS LIST
24 ................ COMPANY NAME
24 ................ COMPANY ADDRESS
24 ................ COMPANY TELEPHONE
25 ................ PRINTER DRIVER (SETUP)
25 ................ PRINTER DRIVER OPTIONS
26 ................ CHANGE DEFAULT PRINTER
27 ................ FULL SCREEN EDIT - F2
27 ................ PRINTER DRIVER DATABASE FIELD DEFINITIONS
28 ................ LAST INVOICE NUMBER
28 ................ PRINTER TYPE
28 ................ INVOICE PRINTER PORT
28 ................ DEFAULT TAX RATE
29 ................ DEFAULT COMMENT
29 ................ SCREEN FONTS
29 ................ SCREEN FONTS LIST
30 ................ READ USER MANUAL
31 ................ SYSTEM
31 ................ REINDEX DATABASES
32 ................ COLOR MONITOR
32 ................ COLOR INTENSITY
33 ................ MISCELLANEOUS ROUTINES
33 ................ MISC ROUTINES MENU:
34 ................ APPEND FROM
36 ................ BROWSE DATABASES
38 ................ COPY (.DBF) TO
40 ................ CREATE DATABASE
42 ................ DELETE RECORDS
43 ................ ERASE FILE
43 ................ EXIT TO DOS
44 ................ INDEX A DATABASE
45 ................ LIST FIELDS
48 ................ MODIFY DATABASE
KISBILL - Keep It Simple Billing and Invoicing System
Table of Contents
Page Subject
──── ───────────────────────────────────────
49 ................ PACK DATABASE
50 ................ RECALL RECORDS
50 ................ RETURN TO MENU
50 ................ RUN (DOS COMMAND)
51 ................ SIMPLE EDITOR
52 ................ SORT DATABASE
53 ................ TYPE (PRINT) FILE
54 ................ ZAP DATABASE
56 ................ HELP SCREENS
57 ................ EXPANDED HELP
58 ................ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
60 ................ DATABASE STRUCTURES
61 ................ DATA DICTIONARY
62 ................ TJS 'Computer' LAB
63 ................ ORDER FORM
KISBILL - Keep It Simple Billing and Invoicing System Page: 1
KISBILL.EXE Copyright (c) 1989-1992 TJS LAB
■ INTRODUCTION
KISBILL is a simple to use and operate billing and invoicing system.
This product was produced to provide a means of billing a client or
customer. Very little setup is required (ie: Your Company Name, and
address). KISBILL utilizes 2 Dbase (tm) compatible databases which contain
the invoice header and detail data. The detail database also serves as an
inventory/lookup file for later invoices. KISBILL is also multi-user, able
to operate on PC based networks, ie: Novell (tm). A simple database
management module is also included to provide you with additional means to
modify, view or report on your data.
Feature Highlights:
Menu Driven A Simple DataBase Management System:
Unlimited Users - Create databases
Multiuser - Edit databases
Sales Graph - Create simple reports/lists
Dbase (tm) compatible - Append files
Read User Manual On Screen - Copy files
EGA/VGA Screen Fonts - Simple Editor
Tax Rates - Modify databases
Laser Formated Invoice
Statements
Check out KISBILL's big brother 'DAYO Business Applications' if you want
more features than KISBILL provides...
TJS LAB │ Messages Can Be Left Online At:
P.O. Box 585366 │
4409 Beaumont Drive │ Compuserve: 76367,1401
Orlando, Florida 32858-5366 │ or
│ Voice Mail: (407) 291-3960
KISBILL - Keep It Simple Billing and Invoicing System Page: 2
■ COPYRIGHT/LICENSE
This manual and software is copyrighted with all rights reserved
by TJS LAB. No copying of this manual or software is authorized without
the prior written consent of TJS LAB. No resale of any part of the source
codes is authorized without the prior written consent of TJS LAB. The only
exception to this rule is the making of backup copies of registered software
disks. TJS LAB retains all rights to KISBILL software, documentation, and
source codes.
■ DISCLAIMER
No warrant is made that this software will work in all environments,
or with all resident programs and hardware configurations. TJS LAB has
tested this software in many environments and found it to perform
as expected, however, this software is licensed "AS IS".
TJS LAB will not be liable for any damage done to your data,
hardware and/or software systems as a result of using KISBILL.
■ REQUIREMENTS
IBM or Compatible CPU, Hard Disk & 640K memory
■ SETUP
Setup is made easier with KISBILL. It will create the necessary databases
and other files it requires. KISBILL is capable of running on a floppy disk,
however, you will be limited in the in number of invoice records. A hard disk
is recommended. If you are going to use a hard disk, copy the contents of
the KISBILL disk (or UnZip KISBILL.ZIP) onto it, into a directory of its
own (ie: \KISBILL).
KISBILL - Keep It Simple Billing and Invoicing System Page: 3
■ MAIN MENU
KISBILL V3.0+, Copyright (c), 1989-1992 TJS LAB ┌──[September 1990]──┐
│S M T W T F S │
╓──────────────────────────╖ ├────────────────────┤
║ Browse & Create Invoices ║ │ 1│
╟──────────────────────────╢ Time: 17:08:07 │ 2 3 4 5 6 7 8│
║ Reports ║ │ 9 10 11 12 13 14 15│
╟──────────────────────────╢ Drive: D: │16 17 18 19 20 21 22│
║ Miscellaneous Routines ║ │23 24 25 26 27 28 29│
╟──────────────────────────╢ Disk Size: 31,950,848 │30 │
║ Configuration ║ └────────────────────┘
╟──────────────────────────╢ Available: 13,900,001
║ Select Routine ║
╚══════════════════════════╝
██░ ██░ ████░ ▄██████▄ █▄███████░ ████░ ██░ ██░
██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
██░██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
████░ ██░ ▀██████▄ █████████░ ██░ ██░ ██░
██░██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
██░ ██░ ████░ ▀██████▀ █▀███████░ ████░ ██████░ ██████░
Keep It Simple Billing & Invoicing
Esc (Exit To DOS) Invoice Maintenance & Printing
■ EXIT TO DOS
Press Esc to bring up a prompt that lets you return to DOS or a calling
menu.
╔═══════════════╗
║╔═════════════╗║
║║╔═══════════╗║║
║║║QUIT? (Y/N)║║║
║║╚═══════════╝║║
║╚═════════════╝║
╚═══════════════╝
KISBILL - Keep It Simple Billing and Invoicing System Page: 4
■ BROWSE, CREATE, MAINTAIN INVOICES
This is the browse routine for the invoices. From this routine, you can
call/run others as listed at the bottom of the screen. What you are viewing
is the records contained in the database INVOICE.DBF. To view the fields not
on the screen, press the right/left arrow keys or press F2 to get a full
screen edit of the fields. To browse/view the detail records (DETAIL.DBF),
you just press F3 and a similar screen will appear.
KISBILL V3.0+, Copyright (c), 1989-1992 TJS LAB ┌──[September 1990]──┐
╔════════════════════════════════════════════════════════════════════════════╗
║ Invoice: 110 Terms: Customer Number: 110 ║
║ Taxes: 0.00 Date: 09/17/90 Name: Joe Morgan, Inc. ║
║ Adjust: 0.00 Attn: Sally ║
║ Freight: 0.00 Address: PO Box 3433 ║
║ Subtotal: 37.00 PO: LA, CA 93939 ║
║ Total: 37.00 ║
║ Paid: 0.00 Status: Open ║
║ Due: 37.00 ║
║ Comment: thank You ║
╟────────────────────[ BROWSE, CREATE, MAINTAIN INVOICES ]───────────────────╢
║ INVOICE NAME CUSNUM ║
║──────────────────────╥────────────────────────────────╥────────────────────║
║ 105 ║ Homely Bodies ║ 105 ║
║ 106 ║ Sal's Newspaper Stand ║ 106 ║
║ 107 ║ Julie Florist ║ 107 ║
║ 108 ║ Jack Echols ║ 108 ║
║ 109 ║ Albrieght Corporation ║ 109 ║
║ 110 ║ Joe Morgan, Inc. ║ 110 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) F2 (Edit) F3 (Detail) F4 (Print/Reprint Invoice)
Ctrl N (Add) Ctrl U (Delete) Ctrl F1 (Reset Subtotal) Alt S (Statements)
Find: F5 (Invoice) F6 (Name) F7 (Cusnum) F8 (Phone) F9 (Customer PO)
17/17
KISBILL - Keep It Simple Billing and Invoicing System Page: 5
■ INVOICE HEADER FULL SCREEN EDIT - F2
A full screen edit will display and allow editing of up to 42 fields.
KISBILL V3.93, Copyright (c), 1989-92 TJS LAB, Inc ┌────[April 1992]───┐
┌────────────────────────────────────────────────────────────────────────────┐
│ INVOICE: 4 │
│ DATE: 04/30/92 │
│ │
│ NAME: Specialities, Inc. (Sample) │
│ CUSTOMER NUMBER: 99999999 │
│ ATTENTION: Butch Marlin │
│ ADDRESS LINE 1: PO Box 7800 │
│ ADDRESS LINE 2: 4400 Arlington Road │
│ CITY: Maitland OPEN: T │
│ STATE: GA AMOUNT PAID: 0.00 │
│ ZIP: 30905-5555 AMOUNT DUE: 0.00 │
│ TELEPHONE: CLASS: │
│ TERMS: CASH │
│ SERVICED BY: │
│ CUST_PO: │
│ TAX: Y TAXES: 0.00 2ND TAXES: 0.00 │
│ ADJUSTMENT: 0.00 │
│ FREIGHT: 0.00 │
│ │
│ COMMENT: Thank You │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
■ BROWSE THE DETAIL RECORDS - F3
To view the detail records, press F3 from the invoice record browse.
Press Esc (once) to exit this routine and return to the browse of the invoice
header records.
┌───────────────────[ BROWSE THE DETAIL RECORDS ]───────────────────────┐
│ INVOICE ITEM DESC QTY │
│───────────╥────────────╥────────────────────────────────╥─────────────│
│ 103 ║ EXXXX ║ Jar # 2 ║ 37.000 │
│ 103 ║ FXXXX ║ Jar # 3 ║ 43.000 │
│ 104 ║ GXXXX ║ Jar # 4 ║ 33.933 │
│ 105 ║ HXXXX ║ Jar # 4.1 ║ 2.000 │
│ 105 ║ IXXXX ║ Jar # 4.25 ║ 234.000 │
│ 106 ║ JXXXX ║ Jar # 4.50 ║ 13.000 │
│ 106 ║ KXXXX ║ Jar # 4.75 ║ 54.000 │
│ 107 ║ LXXXX ║ Jar # 4, Red ║ 45.000 │
│ 108 ║ MXXXX ║ Jar # 3100, Tight Cap ║ 31.000 │
│ 109 ║ NXXXX ║ Jar # 3200, Loose Cap ║ 3.000 │
│ 109 ║ OXXXX ║ Jar # 5 ║ 0.000 │
└───────────────────────────────────────────────────────────────────────┘
Esc (Exit) F1 (Help) F2 (Edit)
Find: F5 (Invoice) F6 (Item) F7 (Description)
Ctrl N (Add) Ctrl U (Delete)
KISBILL - Keep It Simple Billing and Invoicing System Page: 6
■ DETAIL FULL SCREEN EDIT - F2
Like the invoice header records, the detail records can be edited using
the full screen edit routine by press F2.
KISBILL V3.0+, Copyright (c), 1989-1992 TJS LAB ┌──[September 1990]──┐
┌───────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐
│ INVOICE: 4324 │
│ ITEM: FXXXX │
│ DESC: Jar #3 │
│ QTY: 34.000 │
│ PRICE: 3.00 │
│ DATE: 09/02/90 │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
└──────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
■ FIND INVOICE NUMBER
┌─────────────────────────────────────────────────────────────┐
│ Enter INVOICE: 110 │
└───────────────────────────────────────────────────TJS LAB───┘
■ FIND ITEM NUMBER
┌─────────────────────────────────────────────────────────────┐
│ Enter ITEM: 34546 │
└───────────────────────────────────────────────────TJS LAB───┘
■ FIND ITEM DESCRIPTION
┌─────────────────────────────────────────────────────────────┐
│ Enter DESC: Widget │
└───────────────────────────────────────────────────TJS LAB───┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 7
■ PRINT/REPRINT INVOICE - F4
Press F4 to print or reprint any invoice. You will be prompted to enter
the number of copies.
╔══════════════════════════════════════════════════════════════════════════╗
║ Invoice: 110 Customer: 123456 ║
║ Enter Number of Copies: 2 ║
║ ║
║ ║
╚══════════════════════════════════════════════════════════════════════════╝
After entering in the number of copies, you still have one last chance to
align the printer. Press the Enter/Return key to continue.
╔══════════════════════════════════════════════════════════════════════════╗
║ Invoice: 110 Customer: 123456 ║
║ Ready your Laser printer, then Press Enter to Start Printing... ║
║ Press Esc now to abort... ║
║ ║
╚══════════════════════════════════════════════════════════════════════════╝
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
The invoices print onto 8.5 by 11 inch paper at 6 lines per inch with
approximately 66 lines per page.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
The HP printout will do much of the printer setup (ie:LPI & CPI), but no
printer setup takes place on the standard printer.
*** Note, the HP Laser invoice is more 'elaborate'.
Sample of Standard Invoice Next Page.
KISBILL - Keep It Simple Billing and Invoicing System Page: 8
■ EXAMPLE OF THE STANDARD INVOICE
Invoice: 1011 Page 1
Date of Invoice: 11/05/89
Date Printed: 11/05/89
16:11:02
Sams Wholesale Distribution Ctr
Attn: Accounts Receivable
P.O. BOX 335366
Maitland, FL 32458-5366
407-555-5555
Serviced by: Sal
--------------------------------------------------------------------------
Customer: 1208 Terms: NET 10
FLOWERS WORLD Customer Po:
JOSE Taxable: 0.060
15001 EAST RIVER ROAD
SUITE 343
EATONVILLE, FL 93939
393-5555
Comments: I'm sending you a purple ones (out of gold, yellow, and blue)
--------------------------------------------------------------------------
ITEM DESCRIPTION QTY PRICE EXTENDED
---------- ------------------------------ ------ ---------- ----------
REG909 RATHER LARGE JAR 4 34.00 136.00
*** Nothing Follows ***
--------------------------------------------------------------------------
Sales Total: 136.00
Adjustments: 0.00
Freight/Other: 0.00
Subtotal: 136.00
Tax: 8.16
Net Total: 144.16
-------------------------- Paid:- 0.00
x Balance Due: 144.16
KISBILL - Keep It Simple Billing and Invoicing System Page: 9
■ ADD/CREATE INVOICE - CTRL N
Find an existing customer/client by using the Find keys (F5-F9), then
pressing Ctrl N (just press Ctrl N if creating a new customer). A prompt will
appear asking if you wish to use the currently highlighted customer. Respond
with a Y (Yes) or N (No). Press Esc to abort. An edit screen will appear
onto the screen allowing you to enter important 'header' information about
the invoice.
KISBILL V3.0+, Copyright (c), 1989-1992 TJS LAB ┌──[September 1990]──┐
┌───────────────────[ ADD A NEW INVOICE - FULL SCREEN EDIT ]─────────────────┐
│ INVOICE: 111 │
│ DATE: 09/18/90 │
│ │
│ NAME: Frank Slater │
│ CUSTOMER NUMBER: 123456 │
│ ATTENTION: │
│ ADDRESS LINE 1: 143 Ivanhoe Blvd. │
│ ADDRESS LINE 2: │
│ CITY: Orlando OPEN: .T. │
│ STATE: Florida AMOUNT PAID: 0.00 │
│ ZIP: 32878 AMOUNT DUE: 0.00 │
│ TELEPHONE: 407-555-5436 │
│ TERMS: Net 30 │
│ SERVICED BY: MG │
│ CUST_PO: │
│ TAX: N 0.00 │
│ ADJUSTMENT: 0.00 │
│ FREIGHT: 0.00 │
│ │
│ COMMENT: Thank You │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
KISBILL - Keep It Simple Billing and Invoicing System Page: 10
■ ADDING DETAIL ITEMS TO INVOICE
After editing the invoice header record, you will be presented with the
following screen. At this point you are to add the detail items to the
invoice. You can do this using 2 methods:
1. Press Ctrl N to add a blank record. Enter the information as required
2. Press F3 to bring up a selection browse of all past invoice detail
records to select from.
KISBILL V3.0+, Copyright (c), 1989-1992 TJS LAB ┌──[September 1990]──┐
┌───────────────────[ ADD A NEW INVOICE - FULL SCREEN EDIT ]─────────────────┐
│ INVOICE: 112 │
│ DATE: 09/18/90 │
│ │
│ NAME: Tom Johnson │
│ CUSTOMER NUMBER: 112 │
│ ATTENTION: │
│ ADDRESS LINE 1: 4325 Cinderlane Dr. │
│ ADDRESS LINE 2: │
│ ITEM DESCRIPTION QTY PRICE │
│────────────────╥────────────────────────────────╥───────────╥──────────────│
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
Esc (Exit) F1 (Help) F2 (Edit) F3 (Add From Detail)
Ctrl N (Add) Ctrl U (Delete)
Add your line items... (Ctrl N or F3)
KISBILL - Keep It Simple Billing and Invoicing System Page: 11
■ SELECT ITEM FROM PAST SALES - F3
This is the preferred method of adding detail items to your invoice. If
you have ever invoiced with this program, you will find the detail items in
this selection browse. Find the item, then press the Enter/Return key.
┌──────[ Select an Item to be added to this Invoice ]──────┐
│ ITEM DESC PRICE │
│────────────╥────────────────────────────────╥────────────│
│ 6XXXX ║ Jar #1 ║ 4.00 │
│ AXXXX ║ Jar #2 ║ 3.00 │
│ BXXXX ║ Jar #3 ║ 34.00 │
│ BXXXX ║ Jar #4 ║ 34.00 │
│ FXXXX ║ Jar #5 ║ 3.00 │
│ GXXXX ║ Jar #6 ║ 3.00 │
│ HXXXX ║ Jar #7 ║ 3.00 │
│ IXXXX ║ Jar #8 ║ 3.00 │
└──────────────────────────────────────────────────────────┘
After highlighting the item, press Enter/Return, and you will be
presented with a data entry screen for key fields. Use this routine to make
any changes to the detail item record while it is being added to the invoice.
┌──────[ Select an Item to be added to this Invoice ]──────┐
│ │
│ Item: GXXXX │
│ Description: Jar #6 │
│ Price: 34.00 │
│ │
│ Enter Qty: 1.0000 │
│ │
│ │
│ │
│ │
└──────────────────────────────────────────────────────────┘
■ MANUALLY ADD ITEM - CTRL N
If the item does not reside in the past sales (DETAIL.DBF), then press
Ctrl N to add the item. You need to type the information for all fields.
┌──────────────────────────────────────────────────────────┐
│ Item: HXXXX │
│ Description: Jar #7 │
│ Price: 0.00 │
│ │
│ Enter Qty: 1.0000 │
└──────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 12
■ DELETE INVOICE - CTRL U
Press Ctrl U to mark records for deletion, or to recall already deleted
records.
■ RECALCULATE INVOICE SUBTOTAL - CTRL F1
Should you change a price value, quantity, freight, taxes, adjustment,
or paid fields AFTER creating an invoice, you will need to recompute the
invoice subtotal by pressing Ctrl F1.
■ FIND INVOICE
┌─────────────────────────────────────────────────────────────┐
│ Enter INVOICE: 16476 │
└───────────────────────────────────────────────────TJS LAB───┘
■ FIND CUSTOMER NAME
You can enter all or just part (left part) of the name.
┌─────────────────────────────────────────────────────────────┐
│ Enter NAME: Kelly Pace │
└───────────────────────────────────────────────────TJS LAB───┘
■ FIND CUSTOMER NUMBER
┌─────────────────────────────────────────────────────────────┐
│ Enter CUSNUM: 36474 │
└───────────────────────────────────────────────────TJS LAB───┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 13
■ FIND CUSTOMER'S PHONE NUMBER
This search is on the right 4 digits of the telephone number.
┌─────────────────────────────────────────────────────────────┐
│ Enter RIGHT(SPACE(4)+RTRIM(PHONE),4): 1234 │
└───────────────────────────────────────────────────TJS LAB───┘
■ FIND CUSTOMER PURCHASE ORDER NUMBER
This search is on the purchase order number that your customer may have
given you.
┌─────────────────────────────────────────────────────────────┐
│ Enter CUST_PO: 13324-A32 │
└───────────────────────────────────────────────────TJS LAB───┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 13.1
■ PRINT STATEMENT - ALT S
Press Alt S to print a statement listing all open (OPEN=.T.) invoices
for all customers, a specific customer, or for a specific CLASS code.
KISBILL V3.92, Copyright (c), 1989-92 TJS LAB, Inc ┌────[March 1992]────
┌──────────────[ PRINT STATEMENTS FOR OPEN (OPEN=.T.) INVOICES ]─────────────┐
│ │
│ Select Option -> All OPEN │
│ Specific Customer │
│ Specific CLASS │
│ Exit/Abort │
│ │
│ │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Esc (Exit)
■ STATEMENT EXAMPLE
S T A T E M E N T Date: 03/22/92
TJS LAB
Attn: Accounts Receivable
P.O. BOX 5366
Orlando, Florida 32858-5366
407-291-3960
Statement For: MARCHAND,O #263
UPJOHN DAYTONA,
Date Invoice P.O. Total Credit Balance
-------- ------- --------------- ---------- ---------- ----------
07/19/81 263 529082 107.20 0.00 107.20
-------- ------- --------------- ---------- ---------- ----------
Please Pay This Amount (Balance Due) -> 107.20
Amount Enclosed: ______________
Thank You!
KISBILL - Keep It Simple Billing and Invoicing System Page: 14
■ REPORTS
There are 7 Report, 1 Graph, and 2 Label routines available from the
Reports Menu. Most of the reports can be directed to a printer or to a file.
A few of the reports let you set the date range and select an index (ie:
sorted on INVOICE, or NAME). Press Esc to exit this menu...
■ REPORT FORMS
There are 5 report forms required:
INVOICE.FRM - Used with options 1,9
DETAIL.FRM - Used with option 2
ITEM.FRM - Used with option 3
MOVEMENT.FRM - Used with option 4
CUSTOMER.FRM - Used with options 5,6
╔════════════════════════════[ REPORTS MENU ]════════════════════════════╗
║ Select Report Option ║
╟────────────────────────────────────────────────────────────────────────╢
║ 1 - Header Invoice Report (With Date Range & Index Selection) ║
║ 2 - Detail Invoice Report (With Date Range & Index Selection) ║
║ 3 - Product/Item Listing (Unique ITEM) ║
║ 4 - Product/Item Movement (With Date Range) ║
║ 5 - Customers (Unique CUSNUM) ║
║ 6 - Customers (Unique NAME) ║
║ 7 - Address/Mailing Labels ║
║ 8 - Folder Labels (CUSNUM, NAME) ║
║ 9 - Open Invoices ║
╚════════════════════════════════════════════════════════════════════════╝
■ REPORTS LISTING
Header Invoice Report (With Date Range & Index Selection)
Detail Invoice Report (With Date Range & Index Selection)
Product/Item Listing (Unique ITEM)
Product/Item Movement (With Date Range)
Customers (Unique CUSNUM)
Customers (Unique NAME)
Address/Mailing Labels
Folder Labels (CUSNUM, NAME)
Open Invoices
Graph
KISBILL - Keep It Simple Billing and Invoicing System Page: 15
■ HEADER INVOICE REPORT
Use this report to list all your invoice header records (from the
INVOICE.DBF).
This report gives you the option to set the date range of invoices you
want included on the report (from the DATE field in INVOICE.DBF). You can
also select 1 of 3 indexes, type in any heading you want (just defaults to
your company name), and tell it where you want the printout to go (printer
or file).
┌───[ Header Invoice Report (With Date Range & Index Selection) ]─────┐
│ Start Date: 10/12/89 │
│ End Date: 11/11/89 │
│ Select Index: 1 1-Invoice 2-Name 3-Cusnum │
│ Heading: TJS LAB │
│ Printer or File: 1 1-Printer 2-File │
│ │
└─────────────────────────────────────────────────────────────────────┘
* This report is 132 character wide...
KISBILL - Keep It Simple Billing and Invoicing System Page: 16
■ DETAIL INVOICE REPORT
Use this report to list all your invoice detail records (from the
DETAIL.DBF).
┌───[ Detail Invoice Report (With Date Range & Index Selection) ]─────┐
│ Start Date: 10/12/89 │
│ End Date: 11/11/89 │
│ Select Index: 1 1-Invoice 2-Item │
│ Heading: TJS LAB │
│ Printer or File: 1 1-Printer 2-File │
│ │
└─────────────────────────────────────────────────────────────────────┘
■ EXAMPLE OF THE DETAIL INVOICE REPORT
Page No. 1 TJS LAB
11/11/89
INVOICE DETAIL
EXTENDED
INVOICE ITEM DESCRIPTION QTY PRICE TOTAL
-------- ---------- ------------------------------ ----- ---------- ----------
1 MISSILE1 3MT BOMB 1 102.00 102.00
121 MG34 MACHINE GUNS MODEL 34LLD 1 643.00 643.00
141 PISTOL3 PISTOL MODEL III 1 243.00 243.00
156 REG909 RATHER LARGE CARPET 45 10.00 450.00
334 REG909 RATHER LARGE CARPET 2 10.00 20.00
465 REG909 RATHER LARGE CARPET 2 10.00 20.00
677 REG909 RATHER LARGE CARPET 2 10.00 20.00
■ PRODUCT/ITEM LISTING
Use this report to list all 'unique' items in your DETAIL.DBF.
This report has only 2 options; the Heading and printing to printer or
file. The index is on ITEM.
┌───────────────────────[ Product/Item Listing ]──────────────────────┐
│ Heading: TJS LAB │
│ Printer or File: 1 1-Printer 2-File │
│ │
└─────────────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 17
■ EXAMPLE OF THE PRODUCT/ITEM REPORT
Page No. 1 TJS LAB
11/11/89
PRODUCT/ITEM REPORT
ITEM DESCRIPTION PRICE REMARKS
---------- ------------------------------ ---------- ------------------------
1 Jar 34.30 ________________________
2 Big Jar 3.24 ________________________
3 Little Jar 243.00 ________________________
5Y Yellow Jar 170.99 ________________________
6 Missing Jar 433.34 ________________________
8 Wide Mouth Jar 33.00 ________________________
9 2 Mouth Jar 334.00 ________________________
10 3 Sided Jar 99.99 ________________________
■ DETAIL PRODUCT/ITEM MOVEMENT REPORT
Use this report to determine how much of each unique ITEM you have sold
in any date range.
The index is on ITEM.
┌─────────[ Detail Product/Item Movement (With Date Range) ]──────────┐
│ Start Date: 10/12/89 │
│ End Date: 11/11/89 │
│ │
│ Heading: TJS LAB │
│ Printer or File: 1 1-Printer 2-File │
└─────────────────────────────────────────────────────────────────────┘
■ EXAMPLE OF THE PRODUCT/ITEM MOVEMENT REPORT
Page No. 1 TJS LAB
11/11/89
PRODUCT/ITEM MOVEMENT REPORT
EXTENDED
INVOICE QTY PRICE TOTAL
-------- ----- ---------- ----------
** ITEM: 1 DESCRIPTION: 1928 CAR
121 1 12102.00 12102.00
** Subtotal **
1 12102.00
** ITEM: 1020RED DESCRIPTION: RED ROOSTER
20 3 34.00 102.00
21 3 34.00 102.00
2018 43 34.00 1462.00
** Subtotal **
49 1664.00
KISBILL - Keep It Simple Billing and Invoicing System Page: 18
■ CUSTOMERS LIST
Use these 2 reports to create a list of all your active customers. Will
print only one record (from the INVOICE.DBF) for each unique CUSNUM and/or
NAME.
The index in on CUSNUM for option 5, on NAME for option 6.
┌───────────────────[ Customers (Unique CUSNUM) ]─────────────────────┐
│ Heading: TJS LAB │
│ Printer or File: 1 1-Printer 2-File │
│ │
└─────────────────────────────────────────────────────────────────────┘
┌────────────────────[ Customers (Unique NAME) ]──────────────────────┐
│ Heading: TJS LAB │
│ Printer or File: 1 1-Printer 2-File │
│ │
└─────────────────────────────────────────────────────────────────────┘
■ EXAMPLE OF THE CUSTOMERS LIST
Page No. 1 TJS LAB
11/11/89
CUSTOMERS
---------
PHONE
TERMS
CUSNUM NAME & ADDRESS DATE REMARKS
-------- ------------------------------ -------------- --------------------
1202 YELLOW REEDS STORE 342-5555 ____________________
HERMAN GREEN COD
1234 RED LANE 11/05/89
SUITE BLUE 3
WINTER PARK, FL 39393
1203 U GET IT PICKUP AND DELIVERY 304-5555 ____________________
JOE CASH
123 BEAUMONT DRIVE 11/15/87
ORLANDO, FL 39393
1208 FLOWERS WORLD 393-5555 ____________________
JOSE NET 10
15001 EAST RIVER ROAD 10/05/88
SUITE 343
EATONVILLE, FL 93939
1204 GEORGE HARPER WASHINGTON 291-3960 ____________________
Georgy NET 30
24W Minister Road 11/23/89
Harper St
Winter Park, fl 2343 33
KISBILL - Keep It Simple Billing and Invoicing System Page: 19
■ ADDRESS & MAILING LABELS
Use this option to print address or mailing labels onto the standard
label (3.5 inches by 15/16 inches) Mount the labels into your printer, and
when ready, just press Enter on the selected Invoice/Customer record to print
it. Those records that have been printed will be displayed at the top of the
screen. Print as many as you want.
KISBILL - KEEP IT SIMPLE BILLING & INVOICING PROGRAM ┌───[November 1991]──┐
TJS LAB (Version 4.01) │S M T W T F S │
Invoi┌───────────────────────────────────────┐ ├────────────────────┤
Customer Numb│ 3 GEORGE HARPER WASHINGTON │ │ 1 2 3 4│
Da│ 4 GEORGE HARPER WASHINGTON │ │ 5 6 7 8 9 10 11│
┌────────────│ 5 YELLOW REEDS STORE │──────────────────┐ 18│
│ Select the │ 6 FLOWERS WORLD │ │ 25│
│ 1 - Header│ 7 EARL WOODS │Selection) │ │
─│ 2 - Detail└───────────────────────────────────────┘Selection) │──┐│
│ ┌────────────────────[ ADDRESS & MAILING LABELS ]─────────────────────┐ │┘
│ │ INVOICE NAME CUSNUM │ │
│ │─────────────────╥────────────────────────────────╥──────────────────│ │─
│ │ 2019 ║ EARL WOODS ║ 1201 │ │
─│ │ 2021 ║ HARPER BOOKS ║ 1200 │──┘
│ │ 2022 ║ JOHNSON BROS. ║ 1204 │
│ │ 2024 ║ GEORGE HARPER WASHINGTON ║ 1204 │
│ │ 2025 ║ YELLOW REEDS STORE ║ 1202 │
└─│ 2026 ║ SDF ║ 324 │
├─────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Enter (Print Highlighted Label) F5,F6,F7 (Find) │
└─────────────────────────────────────────────────────────────────────┘
Esc (Exit) F1 (Help) F2 (Edit) F3 (Detail) F4 (Print) Alt G (Graph)
F5 (Find Invoice) F6 (Find Name) F7 (Find Cusnum) F8 (Recalc Subtotal)
Ctrl N (Add) Ctrl U (Delete) Alt M (Misc Routines) Alt S (Setup)
■ EXAMPLE OF ADDRESS/MAILING LABELS
│■│┌─────────────────────────────────────┐│■│
│■││ YELLOW REEDS STORE ││■│
│■││ HERMAN GREEN ││■│
│■││ 1234 RED LANE ││■│
│■││ SUITE BLUE 3 ││■│
│■││ WINTER PARK, FL 39393 ││■│
│■│└─────────────────────────────────────┘│■│
│■│┌─────────────────────────────────────┐│■│
│■││ EARL WOODS ││■│
│■││ PO BOX 3432-5555 ││■│
│■││ ORLANDO, FL 23434 ││■│
│■││ ││■│
│■││ ││■│
│■│└─────────────────────────────────────┘│■│
│■│┌─────────────────────────────────────┐│■│
KISBILL - Keep It Simple Billing and Invoicing System Page: 20
■ FOLDER LABELS
Use this option to print labels to attach atop manilla file folders.
This option is the same as option 7, except that that different data is
printed onto the label. The CUSNUM, NAME, PHONE, and CITY, STATE, ZIP are
printed.
■ EXAMPLE OF A FOLDER LABEL
│■│┌─────────────────────────────────────┐│■│
│■││ 50332 ││■│
│■││ HERMAN GREEN ││■│
│■││ 407-291-6987 ││■│
│■││ ORLANDO, FL 34323 ││■│
│■││ ││■│
│■│└─────────────────────────────────────┘│■│
│■│┌─────────────────────────────────────┐│■│
│■││ 8393 ││■│
│■││ EARL WOODS ││■│
│■││ 504-234-2303 ││■│
│■││ WINTER PARK, FL 34222 ││■│
│■││ ││■│
│■│└─────────────────────────────────────┘│■│
│■│┌─────────────────────────────────────┐│■│
■ OPEN INVOICE REPORT
This report is identical to option 1, except that it only prints out
records (from the INVOICE.DBF) that have the OPEN field marked .T.
*** Note that this report is 132 columns wide...
┌────[ Open Invoice Report (With Date Range & Index Selection) ]──────┐
│ Start Date: 10/12/89 │
│ End Date: 11/11/89 │
│ Select Index: 1 1-Invoice 2-Name 3-Cusnum │
│ Heading: TJS LAB │
│ Printer or File: 1 1-Printer 2-File │
│ │
└─────────────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 21
■ SALES GRAPH
Sales History Graph. This option will print onto the screen 2
reports. The first is a graph of the past 12 months of sales. The sum of
each calendar month is calculated. DOES NOT INCLUDE any adjustments (ADJUST),
freight (FREIGHT), or taxes. The data is derived solely from the PRICE*QTY
(from the DETAIL.DBF), if not a deleted record. The second report is just the
summary of the graph; a listing of each month, its total sales and numbers
of items sold. To print either or both of these reports, just 'Print Screen'.
The routine reindexes the DETAIL.DBF each time run (indexed on DATE).
■ GRAPH EXAMPLE #1
TJS LAB
11/05/89 SALES HISTORY, Past 12 Calendar Months
╔═══════════════════════════════════════════════════════════════════════╗
║ ██▓▒░ ║
║ ██▓▒░ ██▓▒░ ║
║ ██▓▒░ ██▓▒░ ║
║ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░║
║ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░║
║ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░║
║ ██$▒░ ██$▒░ ██$▒░ ██$▒░║
║ $ ██1▒░ ██1▒░ $ ██1▒░ ██$▒░ ██1▒░║
║ $ $ $ $ 2 ██2▒░ ██0▒░ 5 ██3▒░ ██7▒░ ██0▒░║
║ 1 8 8 8 0 ██4▒░ ██8▒░ 2 ██3▒░ ██5▒░ ██8▒░║
║ 0 3 3 $ 2 7 ██0▒░ ██2▒░ ██0▒░ ██4▒░ ██6▒░ ██4▒░║
║ 0 5 2 9 5 0 ██8▒░ ██7▒░ ██2▒░ ██5▒░ ██7▒░ ██9▒░║
║ 0 7 3 3 0 3 ██5▒░ ██3▒░ ██7▒░ ██7▒░ ██0▒░ ██6▒░║
║ 0 1 1 3 2 5 ██0▒░ ██6▒░ ██1▒░ ██6▒░ ██2▒░ ██3▒░║
║ . . . . . . ██.▒░ ██.▒░ ██.▒░ ██.▒░ ██.▒░ ██.▒░║
║ 0 1 1 0 1 ██4▒░ ██0▒░ ██1▒░ ██3▒░ ██1▒░ ██4▒░ ██0▒░║
║ 0▒░ ██6▒░ ██6▒░ 0▒░ ██6▒░ ██0▒░ ██0▒░ ██6▒░ ██2▒░ ██6▒░ ██6▒░ ██8▒░║
╟─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────╢
║Dec88│Jan89│Feb89│Mar89│Apr89│May89│Jun89│Jul89│Aug89│Sep89│Oct89│Nov89║
╚═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╝
Total Dollars YTD: $6,487,372.06 Total Pieces: 2255
KISBILL - Keep It Simple Billing and Invoicing System Page: 22
■ GRAPH EXAMPLE #2
TJS LAB
11/05/89 SALES HISTORY, Past 12 Calendar Months
╔═══════════════════════════════════════════════════════════════════════╗
║╔═[ Summary ]════════════════════════════════════════╗██▓▒░ ║
║║ Month Year Total Sales Total Items║██▓▒░ ║
║║ November 1989 $1,084,963.08 477 ║██▓▒░ ║
║║ October 1989 $756,702.46 268 ║██▓▒░ ║
║║ September 1989 $1,334,576.16 246 ║██▓▒░ ██▓▒░║
║║ August 1989 $520,271.32 363 ║██▓▒░ ██▓▒░║
║║ July 1989 $1,082,736.16 128 ║██▓▒░ ██▓▒░║
║║ June 1989 $1,240,850.00 495 ║██$▒░ ██$▒░║
║║ May 1989 $207,035.40 72 ║██1▒░ ██$▒░ ██1▒░║
║║ April 1989 $82,502.16 27 ║██3▒░ ██7▒░ ██0▒░║
║║ March 1989 $933.00 9 ║██3▒░ ██5▒░ ██8▒░║
║║ February 1989 $83,231.16 30 ║██4▒░ ██6▒░ ██4▒░║
║║ January 1989 $83,571.16 40 ║██5▒░ ██7▒░ ██9▒░║
║║ December 1988 $10,000.00 100 ║██7▒░ ██0▒░ ██6▒░║
║╚════════════════════════════════════════════════════╝██6▒░ ██2▒░ ██3▒░║
║ . . . . . . ██.▒░ ██.▒░ ██.▒░ ██.▒░ ██.▒░ ██.▒░║
║ 0 1 1 0 1 ██4▒░ ██0▒░ ██1▒░ ██3▒░ ██1▒░ ██4▒░ ██0▒░║
║ 0▒░ ██6▒░ ██6▒░ 0▒░ ██6▒░ ██0▒░ ██0▒░ ██6▒░ ██2▒░ ██6▒░ ██6▒░ ██8▒░║
╟─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────╢
║Dec88│Jan89│Feb89│Mar89│Apr89│May89│Jun89│Jul89│Aug89│Sep89│Oct89│Nov89║
╚═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╝
Total Dollars YTD: $6,487,372.06 Total Pieces: 2255
KISBILL - Keep It Simple Billing and Invoicing System Page: 23
■ CONFIGURATION
This routine defines your company name, address, telephone number,
invoice settings, printer settings, screen fonts. Other options allow you
to view your system data, set color & intensity, and read/view the user
manual.
KISBILL V3.0+, Copyright (c), 1989-1992 TJS LAB ┌──[September 1990]──┐
╔════════════════════════╗ │S M T W T F S │
╓║ CONFIGURATION ║╖ ├────────────────────┤
║╟────────────────────────╢║ │ 1│
╟║ Company Name ║╢ Time: 17:44:55 │ 2 3 4 5 6 7 8│
║║ Company Address ║║ │ 9 10 11 12 13 14 15│
╟║ Company Telephone ║╢ Drive: D: │16 17 18 19 20 21 22│
║║ Printer Driver/Setup ║║ │23 24 25 26 27 28 29│
╟║ Last Invoice Number ║╢ Disk Size: 31,950,848 │30 │
║║ Invoice Printer Type ║║ └────────────────────┘
╟║ Invoice Printer Port ║╢ Available: 1,861,632
║║ Default Tax Rate ║║
╚║ Default Comment ║╝
║ Screen Font ║▄██████▄ █▄███████░ ████░ ██░ ██░
║ Read User Manual ║██░ ██░ ██░ ██░ ██░ ██░
║ System ║██░ ██░ ██░ ██░ ██░ ██░
╟────────────────────────╢██░ ██░ ██░ ██░ ██░ ██░
║ Select Option ║▀██████▄ █████████░ ██░ ██░ ██░
╚════════════════════════╝ ██░ ██░ ██░ ██░ ██░ ██░
██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
██░ ██░ ████░ ▀██████▀ █▀███████░ ████░ ██████░ ██████░
Keep It Simple Billing & Invoicing
Esc (Exit To DOS) KISBILL Configuration Settings
■ CONFIGURATION SETTINGS LIST
Company Name Default Comment
Company Address Screen Font
Company Telephone Read User Manual
Printer Driver/Setup System
Last Invoice Number Reindex Databases
Invoice Printer Type Color
Invoice Printer Port High Intensity
Default Tax Rate
KISBILL - Keep It Simple Billing and Invoicing System Page: 24
■ COMPANY NAME
Enter your company name as you want it printed onto the invoice.
╔══════════════════════════════[ COMPANY NAME ]══════════════════════════════╗
║ Enter Your Company Name: TJS LAB ║
╚════════════════════════════════════════════════════════════════════════════╝
■ COMPANY ADDRESS
Enter your company address as you want it printed onto the invoice.
╔════════════════════════════[ COMPANY ADDRESS ]═════════════════════════════╗
║ Address Line 1: Attn: Accounts Receivable ║
║ Address Line 2: P.O. BOX 533466 ║
║ City, State ZIP: Maitland, FL 32458-5366 ║
╚════════════════════════════════════════════════════════════════════════════╝
■ COMPANY TELEPHONE
Enter your company telephone number as you want it printed onto the
invoice.
╔═══════════════════════════[ COMPANY TELEPHONE ]════════════════════════════╗
║ Enter Your Company Telephone: 407-291-3960 ║
╚════════════════════════════════════════════════════════════════════════════╝
KISBILL - Keep It Simple Billing and Invoicing System Page: 25
■ PRINTER DRIVER (SETUP)
This routine was added to preclude you from having to get out of your
seat to change the printer settings.
The most important printer selections (ie: font size, lines per inch,
orientation, ...) are made easy to evoke.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
║ ║
║ Select Option -> Eject ║
║ Line feed ║
║ Normal Size ║
║ Use this routine to set your Small/Condensed ║
║ printer up with one or more Bold On ║
║ of the setup strings and Bold Off ║
║ commands listed to the right. 6 Lines per Inch ║
║ 8 Lines per Inch ║
║ Select the 'Change Printer Print Landscape (Laser Only) ║
║ Default' option to change Print Portrait (Laser Only) ║
║ printer types. Reset Printer ║
║ Current printer is set to: Print Special String 1 ║
║ Okidata Print Special String 2 ║
║ Print Special String 3 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
■ PRINTER DRIVER OPTIONS
There are 18 printer driver options to select from. The last option is
to set the default printer, and the next to last is a 'SHELL' function that
runs a DOS command or program. The remainder are strings/codes that are sent
to the printer.
Eject Print Portrait (Laser Only)
Line feed Reset Printer
Normal Size Print Special String 1
Small/Condensed Print Special String 2
Bold On Print Special String 3
Bold Off Print Special String 4
6 Lines per Inch Print Special String 5
8 Lines per Inch Run DOS Command/Program
Print Landscape (Laser Only) Change Default Printer
KISBILL - Keep It Simple Billing and Invoicing System Page: 26
■ CHANGE DEFAULT PRINTER
The last option is to change/set the default printer. This printer
driver routine comes with 4 default printer types, Epson, HP Laser, Star,
and Okidata.
You can add (Ctrl N) as many as you want.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ Current Default Printer is set to: Okidata ║
╟────────────────────────────────────────────────────────────────────────────╢
║ NAME LINEFEED ║
║─────────────────────────────────────╥──────────────────────────────────────║
║ Epson & Compatibles ║ CHR(10) ║
║ HP Laser & Compatibles ║ CHR(10) ║
║ Star Micro Gemini ║ CHR(10) ║
║ Okidata ║ CHR(10) ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add)
KISBILL - Keep It Simple Billing and Invoicing System Page: 27
■ FULL SCREEN EDIT - F2
When entering the printer codes, the string must be in the valid format
or it will not be printed later when requested...
┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐
│ NAME: Epson & Compatibles │
│ LINEFEED: CHR(10) │
│ NORMAL: CHR(27)+CHR(18) │
│ SMALL: CHR(27)+CHR(15) │
│ BOLDON: CHR(27)+CHR(69) │
│ BOLDOFF: CHR(27)+CHR(70) │
│ _6LPI: CHR(27)+CHR(50) │
│ _8LPI: CHR(27)+CHR(48) │
│ PORTRAIT: │
│ LANDSCAPE: │
│ RESET: CHR(27)+CHR(64) │
│ SPEC_STR1: │
│ SPEC_STR2: │
│ SPEC_STR3: │
│ SPEC_STR4: │
│ SPEC_STR5: │
│ RUN_CMD: │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
■ PRINTER DRIVER DATABASE FIELD DEFINITIONS
NAME - Name of printer. Type in anything you wish here
LINEFEED - Code to advance printer one line
NORMAL - Normal font/character size
SMALL - Small font/character size
BOLDON - Bold/Emphasized
BOLDOFF - Bold/Emphasized off
_6LPI - Code to set printer to print 6 lines per inch
_8LPI - Code to set printer to print 8 lines per inch
PORTRAIT - Code to set lazer printer to print upright (normal)
LANDSCAPE - Code to set lazer printer to print sideways
RESET - Reset printer code
SPEC_STR1 - Any special printer string, ie: print double, skip perforation,
SPEC_STR2 - print very tiny, ...
SPEC_STR3 - "
SPEC_STR4 - "
SPEC_STR5 - "
RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ...
KISBILL - Keep It Simple Billing and Invoicing System Page: 28
■ LAST INVOICE NUMBER
The invoice numbers start at this 'Last Invoice #' value + 1. The default
is to have a first invoice number of '1'.
┌──────────────────────────[ LAST INVOICE NUMBER ]───────────────────────────┐
│ Enter Last Invoice Number: 112 │
└────────────────────────────────────────────────────────────────────────────┘
■ PRINTER TYPE
This option wants to know what type of printer you are using. The
only difference between the two is that if you select the HP Laser option,
you will be prompted to select the number of copies each time you print an
invoice. Of course the HP Laser invoice is much prettier...
┌──────────────────────────────[ PRINTER TYPE ]──────────────────────────────┐
│ Invoice type can be in a standard or laser format. │
│ The STANDARD printer type is a Epson/IBM Proprinter compatible printer. │
│ The LASER printer type is a Hewlett Packard Laser compatible printer. │
│ Special Laser codes are sent to the LASER option. │
│ │
│ Enter Your Laser Printer Type -> STANDARD │
│ LASER │
└────────────────────────────────────────────────────────────────────────────┘
■ INVOICE PRINTER PORT
Select a valid printer port (1, 2 or 3). Note, most printers are LPT1,
so you will probably select '1' as the invoice printer port.
┌──────────────────────────[ INVOICE PRINTER PORT ]──────────────────────────┐
│ Enter Your Report Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ DEFAULT TAX RATE
The next prompt is for the default sales tax. The default is 6% (as in
Florida). At invoice time, the default is to charge tax.
┌────────────────────────────[ DEFAULT TAX RATE ]────────────────────────────┐
│ Enter Your Default Tax Rate: 0.00000 │
└────────────────────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 29
■ DEFAULT COMMENT
This phrase is printed onto the invoice. It can be edited/changed during
the invoicing process though.
┌────────────────────────────[ DEFAULT COMMENT ]─────────────────────────────┐
│ This comment is printed onto every Invoice. │
│ │
│ Enter Default Comment: Thank You Mary │
└────────────────────────────────────────────────────────────────────────────┘
■ SCREEN FONTS
Screen fonts are for computers supporting an EGA or VGA video card and
monitor. Select 1 of 18 fonts for your computer screen. Note, the font will
remain loaded until you reboot the computer or run another program that
resets the screen to its default settings. Upon entering KISBILL, the font
will reset the screen font to the selected one automatically.
╔═══[ SCREEN FONTS ]═══════════════════════════╗
║ ║
║ Select Font -> Standard (Normal) ║
║ Old English ║
║ Avante Garde ║
║ Bauhaus ║
║ Bodoni ║
║ Esc (Exit) Broadway ║
║ Script I ║
║ Script II ║
║ Calligraphy ║
║ Garamond ║
║ Legend ║
║ Percy ║
║ Park Avenue ║
║ ║
╚══════════════════════════════════════════════╝
Esc (Exit To DOS) KISBILL Configuration Settings
■ SCREEN FONTS LIST
Standard (Normal) Garamond
Old English Legend
Avante Garde Percy
Bauhaus Park Avenue
Bodoni Computer
Broadway Italic I
Script I Italic II
Script II Digital
Calligraphy Romany
KISBILL - Keep It Simple Billing and Invoicing System Page: 30
■ READ USER MANUAL
Use this option to view/read the documentation & user manual for KISBILL.
Use the arrow and/or page up/down keys to navigate the document. Press Alt S
to find a word or phrase, or F1 for a more detailed help description.
╒════════════════════════════════════════════════════════════════════════════╕
│ 39 ................Order Form │
│ KISBILL - Keep It Simple Billing and Invoicing System Page 23│
│ │
│ │
│ KISBILL.EXE Copyright (c) 1989-92 TJS LAB, Inc. │
│ │
│ │
│ KISBILL is a simple to use and operate billing and invoicing system. Thi│
│product was produced to provide a means of billing a client or customer. Ver│
│little setup is required (ie: Your Company Name, and address). KISBILL utili│
│2 Dbase (tm) compatible databases which contain the invoice header and detai│
│data. The detail database also serves as an inventory/lookup file for later │
│invoices. KISBILL is also multi-user, able to operate on most of the PC base│
│networks, ie: Novell (tm). A simple database management module is also inclu│
│to provide you with additional means to modify, view or report on your data.│
│ │
│ │
│ Feature Highlights: │
│════════════════════════════════════════════════════════════════════════════│
│KISBILL.DOC │KISBILL.DOC │ │ │ │ │ │
╘════════════════════════════════════════════════════════════════════════════╛
KISBILL - Keep It Simple Billing and Invoicing System Page: 31
■ SYSTEM
This option will display information about your computer onto the
screen. Also it allows you to change the system time and date. Note, this
time and date change may not work on all networks...
╔═════════════════════════════════[ SYSTEM ]════════════════════════════════╗
║ DOS Version: 3.310 ║
║ DOS Memory: 640 ║
║ Free DOS Memory: 41,888 ║
║ Extended Memory: 0 ║
║ Expanded Memory: 0 ║
║ Parallel Ports: LPT1: ║
║ Serial Ports: COM1: COM2: ║
║ CPU Type: 80286 ║
║ Monitor Type: VGA ║
║ Available Drives: ABCDE ║
║ Current Drive: D: ║
║ Volume Name: ║
║ Disk Size: 31,950,848 ║
║ Available Space: 1,845,248 5.78% of Disk Open... ║
║ Disk Clusters: 15,601 ║
║ Cluster Size: 2,048 ║
║ Sectors: 4 ║
║ Sector Size: 512 ║
║ Date: 09/18/90 ║
║ Time: 19:54:42 ║
║ Change Date and/or Time? (Y/N) ║
╚═══════════════════════════════════════════════════════════════════════════╝
Esc (Exit To DOS)
■ REINDEX DATABASES
Should the need arise during the day to reindex the databases, or you
suspect that the indexes are corrupted, use this option to recreate the
indexes for databases: INVOICE.DBF & DETAIL.DBF. A progress graph of the
indexing is displayed...
┌──────────────────────────────────────────────────────────┐
│ Database Name: invoice.DBF │
│ Index Name: name.NTX │
│ Number of Records: 19 │
│ ┌──────────────────────────────────────────────────┐ │
│ │████████████████████████████ │ │
│ └──────────────────────────────────────────────────┘ │
│ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │
└──────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 32
■ COLOR MONITOR
If you have a color monitor and wish to display colors, then select
Y (YES), else select N (NO) for monochrome. The default is color, low
intensity.
╔═════════════════════════════[ COLOR MONITOR ]══════════════════════════════╗
║ If you have a color monitor and wish to display colors, then select Y, ║
║ (YES), else select N (NO) for monochrome and others. ║
║ The default is color, high intensity ║
║ ║
║ Do you have a color monitor? (Y/N) ║
╚════════════════════════════════════════════════════════════════════════════╝
■ COLOR INTENSITY
If you have a color monitor and want high intensity (bright) colors,
select Y for the high intensity. Default is high intensity.
╔════════════════════════════[ COLOR INTENSITY ]═════════════════════════════╗
║ Intensity is only applicable with color set to Y. ║
║ It will make your colors brighter... ║
║ ║
║ Set Color Intensity On? (Y/N) ║
╚════════════════════════════════════════════════════════════════════════════╝
KISBILL - Keep It Simple Billing and Invoicing System Page: 33
■ MISCELLANEOUS ROUTINES
The MISC routines is a collection of 17 very useful Database Management
Routines. These routines provide you with the 'ability to do whatever was
left out of the rest of the program...'. These routines were modeled after
dBase (tm) III+/IV functions. Familiarity with dBase will help with the
understanding and execution of these routines.
USE WITH CAUTION!
YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES
YOU CAN ALSO MESS THINGS UP PERMANENTLY!
■ MISC ROUTINES MENU:
KISBILL V3.0+, Copyright (c), 1989-1992 TJS LAB ┌──[September 1990]──┐
╔════════════════════╗ │S M T W T F S │
║ MISC ROUTINES ║─────╖ ├────────────────────┤
╟────────────────────╢ices ║ │ 1│
║ APPEND FROM ║─────╢ Time: 17:44:47 │ 2 3 4 5 6 7 8│
║ BROWSE DATABASES ║╔═══════════════════════╗ │ 9 10 11 12 13 14 15│
║ COPY (.DBF) TO ║║Any changes to the ║ │16 17 18 19 20 21 22│
║ CREATE DATABASE ║║databases: INVOICE.DBF ║ │23 24 25 26 27 28 29│
║ DELETE RECORDS ║║and/or DETAIL.DBF WILL ║,848 │30 │
║ ERASE FILE ║║corrupt their indexes, ║ └────────────────────┘
║ EXIT TO DOS ║║and WILL require a ║632
║ INDEX A DATABASE ║║Reindexing! Reindex ║
║ LIST FIELDS ║║both databases from the║
║ PACK DATABASE ║║Configuration Menu... ║█░ ████░ ██░ ██░
║ MODIFY DATABASE ║╚═══════════════════════╝██░ ██░ ██░ ██░
║ RECALL RECORDS ║░ ██░ ██░ ██░ ██░ ██░ ██░
║ RETURN TO MENU ║░ ██░ ██░ ██░ ██░ ██░ ██░
║ RUN (DOS COMMAND) ║░ ▀██████▄ █████████░ ██░ ██░ ██░
║ SIMPLE EDITOR ║░ ██░ ██░ ██░ ██░ ██░ ██░
║ SORT DATABASE ║░ ██░ ██░ ██░ ██░ ██░ ██░
║ TYPE (PRINT) FILE ║░ ██░ ██░ ██░ ██░ ██░ ██░
║ ZAP DATABASE ║█░ ▀██████▀ █▀███████░ ████░ ██████░ ██████░
╟────────────────────╢ Keep It Simple Billing & Invoicing
║ Select Option ║
╚════════════════════╝ Database Management Routines
KISBILL - Keep It Simple Billing and Invoicing System Page: 34
■ APPEND FROM
Used to copy records from one database into another database, or to
create records from ASCII files (SDF or DELIMITED).
The Initial Screen will prompt you to enter the file name of the database
you are to append/copy the data into. At this point, you can either type in
the name of the target database, or ...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
└────────────────────────────────────────────────────────────────────────────┘
If it exists in the current directory, press enter on an empty prompt to
display all databases to select from.
┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │INVENT.DBF │ 375 │ 09/16/89 │ │
│ │AR.DBF │ 7219 │ 09/16/89 │ │
│ │HISTORY.DBF │ 103 │ 09/16/89 │ │
│ │PERSONS.DBF │ 24271 │ 09/16/89 │ │
│ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
│ │
└───────────────────────────────────────────────────────────────────────────┘
The next prompt will be to select the type of Append:
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
└──────────────────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 35
If you are appending from another database (.DBF) then select 'Standard'.
Select the SDF option if you are appending from a 'flat' ASCII file.
Select the DELIMITED option if you are appending from a delimited ASCII
file. Delimited files contain records in which the fields are separated by
commas, and its character fields contained in double quotes...
If you select a Standard Append, you will then be prompted to enter the
name of the database you wish to get the data from. If you selected the SDF
or DELIMITED options, then enter the file name containing the data to be
appended into your target database.
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into PERSONS.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: PERSON1.TXT │
│ │
│ │
└──────────────────────────────────────────────────────────────────────────┘
The number of records appended into the target database will be displayed
upon completion of the task...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF From INVENTY.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: INVENTY.DBF │
│ │
│ │
│ │
│ There Were 1 Records Appended Into INVENT.DBF │
│ │
│ │
│ │
│ Press Any Key To Continue... │
│ │
└────────────────────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 36
■ BROWSE DATABASES
Used to edit/view records in a database. Enter the database name you wish
to edit/browse, or if it exists in the current directory, press enter on an
empty prompt to bring up a window box to select from.
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: INVENT.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
If there exists an index (.NDX or .NTX), with the same name as the
database, it will be utilized...
An example of a browse screen:
TJS LAB, PO BOX 585366
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ MFG_PART DESC PRICE LIST │
│──────────────────╥────────────────────────────────╥────────────╥───────────│
│ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │
│ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │
│ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │
│ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │
│ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │
│ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │
│ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │
│ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │
│ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │
│ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │
│ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │
│ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │
│ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │
│ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │
│ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │
│ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │
│ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │
├──────────────────╨────────────────────────────────╨────────────╨───────────┤
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
51/60
KISBILL - Keep It Simple Billing and Invoicing System Page: 37
To edit a memo field, just highlight the field, and start typing.
* * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING!
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ PRICE LIST YOURPART NOTES │
│───────────────────────╥────────────╥─────────────────╥─────────────────────│
│ 896.16 ║ 1792.32 ║ ║ <Memo> │
│ 1064.19 ║ 2128.38 ║ ║ <Memo> │
│ 672.12 ║ 1344.24 ║ ║ <Memo> │
│ 1736.31 ║ 3472.62 ║ ║ <Memo> │
│ 504.09 ║ 1008.18 ║ ║ <Memo> │
│ 784.14 ║ 1568.28 ║ ║ <Memo> │
│ 1400.25 ║ 2800.50 ║ ║ <Memo> │
┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐
│You can edit memo fields too... │
│ │
│ │
│ │
│ │
│ │
│ │
└───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
Special keys for 'moving around' the BROWSE screen are:
Left Arrow Key - Move to next field to your left
Right Arrow Key - Move to next field to your right
Ctrl Home - Go to the leftmost field
Ctrl End - Go to the rightmost field (on the end of the record)
Up Arrow - Move highlight to the previous record
Down Arrow - Move highlight to the next record
PgUp - Page up a full screen of records
PgDn - Page down a full screen of records
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end or last record of the file
Ctrl N - Add a record (where applicable)
Ctrl U - Delete a record (where applicable)
F5 - To seek/find a record based upon the active index
Esc - Exit the current operation
Remember that there are many more fields to the right of the screen.
Press the right arrow key to view them...
KISBILL - Keep It Simple Billing and Invoicing System Page: 38
■ COPY (.DBF) TO
Copy records to another (new) database. Use this option to copy select
records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can
also be used to create backups of data (IE: copy to floppy).
┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │HARPS.DBF │ 375 │ 09/16/89 │ │
│ │INVENT.DBF │ 7335 │ 09/16/89 │ │
│ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │
│ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │
│ │AP.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
└────────────────────────────────────────────────────────────────────────────┘
The next prompt will be to select the type of COPY TO option you want:
┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: INVENT.DBF │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ │
│ Copy Records From INVENT.DBF │
└────────────────────────────────────────────────────────────────────────────┘
The Standard option is simply creating another database (.DBF). The SDF
and DELIMITED options will create ASCII files. The STRUCTURE option creates a
new database with the same file structure as the initial database (no
records copied).
KISBILL - Keep It Simple Billing and Invoicing System Page: 39
The next prompt (optional), requires some knowledge of dBase (tm). This
prompt is requesting the user to to enter a condition or filter. If all
records are to be copied, just press Enter on an empty prompt.
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW.DBF │
│ │
│ Enter Condition: │
│ Sample condition: COST > 100 │
│ │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
This 'Condition' option is useful for coping only specific records into a
new location. Any valid dBase/Clipper statement (as shown next) is
fine...
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW DBF │
│ │
│ Enter Condition: PRICE>0 │
│ Sample condition: COST > 100 │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 40
The following window message will appear while the COPY TO routine does
its task:
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW10 │
│ │
│ Enter Condition: PRICE>0 │
│ Sample cond┌───────────────────────────────────────────────┐ │
│ │┌─────────────────────────────────────────────┐│ │
│ CONDITION: ││┌───────────────────────────────────────────┐││ │
│ │││┌─────────────────────────────────────────┐│││ │
│ ││││Hold those camels while I do this COPY TO││││ │
│ │││└─────────────────────────────────────────┘│││ │
│ ││└───────────────────────────────────────────┘││ │
│ │└─────────────────────────────────────────────┘│ │
│ └───────────────────────────────────────────────┘ │
│ Copy Records From SDF To NEW10 │
└────────────────────────────────────────────────────────────────────────────┘
■ CREATE DATABASE
Create a new database. This routine lets you create entirely new database
structures. At the FIELD_NAME field, enter a unique field name. At the
FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date,
'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the
size/length of the character and/or numeric field. At the FIELD_DEC field,
enter the number of decimals for the numeric field.
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ ║ ║ 0 ║ 0 │
│ ║ ║ ║ │
│ ║ ║ ║ │
┌─────────────│ ║ ║ ║ │────────────┐
│ │ ║ ║ ║ │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 41
* * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * *
IT IS SLIGHTLY BOTHERSOME
SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING...
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to edit the new database.
This error may even cause your computer to hang!
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will just negate your efforts..
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ NAME ║ C ║ 30 ║ 0 │
│ AGE ║ N ║ 5 ║ 1 │
│ DEAD ║ L ║ 1 ║ 0 │
│ BIRTHDATE ║ D ║ 8 ║ 0 │
┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐
│ │ ║ ║ 0 ║ 0 │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│ ║ ║ ║ │
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 42
■ DELETE RECORDS
Delete selected records from databases. The first prompt is for the name
of the database you wish to mark records for deletion. Like many of the other
routines, you can press enter on an empty prompt to bring up all databases
that exist in the current directory:
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│D.DBF │ 259 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/16/89 │
│XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└────────────────────────────────────────────────────────────────────────────┘
After selecting the database, all its fields will be presented atop the
screen so as to aid the user in entering a condition/filter. The use of the
condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax
is required. Note the use of the Clipper Function: EMPTY().
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐
│ Enter Database Name: TRASH │
│ Delete Records For Condition: EMPTY(PART) │
│ Sample condition: COST > 100 │
│ CONDITION: EMPTY(PART) │
│ Number of Records Deleted: 208 │
│ Press any key to continue... │
└────────────────────────────────────────────────────────────────────────────┘
The number of records deleted will be displayed upon the screen as
depicted just above...
KISBILL - Keep It Simple Billing and Invoicing System Page: 43
■ ERASE FILE
Erase a file (forever!). Use this option with extreme care!
Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY
REMOVED FROM EXISTENCE
NO SECOND CHANCES HERE...
The first prompt is for the file name. You can press enter on an empty
prompt to bring up a window selection of all files in the current directory.
┌────────────────────────┐
┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘
│BKDOOR.DOC │ 37029 │ 09/17/89 │
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│D.DBF │ 259 │ 09/16/89 │
│D.DBT │ 512 │ 09/16/89 │
│DAYOBK.BAK │ 36879 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
│DAYOBK.OBJ │ 35585 │ 09/16/89 │
│DAYOCAL.MAP │ 35 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│DDD.DBT │ 512 │ 09/16/89 │
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
* To ERASE a file, just highlight it, then press Enter...
■ EXIT TO DOS
This option will close all open files and databases and exit to DOS
without having to return to the main menu exit routine.
KISBILL - Keep It Simple Billing and Invoicing System Page: 44
■ INDEX A DATABASE
You will be prompted to select the database you wish to index. After
selecting the database, by typing in the name or pressing Enter on an empty
prompt (then selecting from the window), you will be given a listing of all
fields in that database atop the screen.
┌────────[ PICK A DATABASE ]───────────┐.
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DAD.DBF │ 259 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SPW.DBF │ 7335 │ 09/16/89 │
│SOW.DBF │ 103 │ 09/16/89 │
│BOY.DBF │ 24387 │ 09/17/89 │
│SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
You will now be prompted to enter the name of the Index File. It will be
(by default), named exactly the same as the selected database, with the
exception of the extension. This will default to .NDX or .NTX depending on
whether you linked NDX.OBJ with your application.
*** Remember that the BROWSE routine only looks at indexes with the same
name as the database.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
└───────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 45
At the prompt for the index key, enter a field name, or a valid
dBase/Clipper expression.
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
│ Enter the Key Expression: PART+MFG_PART │
└───────────────────────────────────────────────────────────────┘
■ LIST FIELDS
List fields to screen or printer. This routine is a great tool for
providing simple reports and lists. The first prompt will be for the database
you wish to work with. Type the name of the file, or press Enter on an empty
prompt to bring up a window of all databases in the current directory for
selection.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│INVEND.DBF │ 259 │ 09/16/89 │
│INVENT.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SOMEDAY.DBF │ 7335 │ 09/16/89 │
│TANGO.DBF │ 103 │ 09/16/89 │
│AP.DBF │ 24387 │ 09/17/89 │
│BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 46
The next prompt is for a condition or filter. This makes it possible to
list only specific records that meet that condition you enter. The condition
must be a valid dBase/Clipper expression, or none (to list all).
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌─────────────────────────────────────────────────────┐
│ Enter Filter: │
│ IE: ID = "SAM0909" .AND. RETAIL > 10000 │
└─────────────────────────────────────────────────────┘
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: │
│ │
└───────────────────────────────────────────────────────────────┘
A window box appears next displaying all the fields in the selected
database and an option to list all fields. Highlight any combination of
fields ( or ALL) that you want listed.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║ ├─────────────────┤ ║
╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝
│RECNO() │
│MFG_PART │
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 47
The fields you select will be displayed at center top of screen. Press
Esc to exit the "PICK THE FIELDS YOU WANT LISTED" window.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
At the next prompt, you can send the list to the SCREEN, PRINTER OR FILE.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│DESC┌──────────────────────────────────────────────────────────────────┐
│PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │
│LIST│ │
│YOUR└──────────────────────────────────────────────────────────────────┘─┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 48
The list is very simple, and if displayed onto the screen, may look like
the following:
PART MFG_PART PRICE
4523 0.00
DAYO9S 41926 1904.34
DAYO10S 13564 616.11
DAYOCOMP 45625 2072.37
DAYOALLS 43159 1960.35
INDEXER 50558 2296.41
INDEXERS 51791 2352.42
5 DEMO 4932 224.04
DAYO13S 20963 952.17
MENUS 53024 2408.43
OFFSITEP 56724 2576.46
ONSITEP 57957 2632.47
DAYO2S 24662 1120.20
DAYO9 40693 1848.33
DAYO10 12331 560.10
DAYOCAL$ 44392 2016.36
DAYO13 19730 896.16
DAYO2 23429 1064.19
DAYO11 14797 672.12
DAYO8 38227 1736.31
DAYO1 11098 504.09
DAYO12 17264 784.14
DAYO5 30828 1400.25
......PRESS ANY KEY TO CONTINUE......
■ MODIFY DATABASE
Change the fields/structure of a database. You can add new fields, delete
fields, change the length and type of field in any of the databases. At the
FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter
a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M'
for memofield. At the FIELD_LEN field, enter the size/length of the
character and/or numeric field. At the FIELD_DEC field, enter the number of
decimals for the numeric field.
********************************************************
*** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST ***
*** IT IS SLIGHTLY BOTHERSOME SORRY! ***
********************************************************
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to access the database.
This error may even cause your computer to hang!
KISBILL - Keep It Simple Billing and Invoicing System Page: 49
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will just negate your efforts..
■ PACK DATABASE
Pack a database (removed deleted records). This option will permanently
remove any records marked for deletion. This is another routine you should
use with great care! As in many of the other of the routines, you will be
prompted to enter the name of the database you wish to pack. Enter the name
or press Enter on an empty prompt to view the window.
┌─────┐
│PACK!│
└─────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│GOODDATA.DBF │ 259 │ 09/16/89 │
│HAP.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│LOIN.DBF │ 103 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/17/89 │
│FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
After selecting the database, you will be prompted to respond with a Yes
or No (to Pack or not to Pack...). This is the last chance you have to change
your mind...
┌──────────────────────────────────────────────────────────────────────────┐
│ PACK TOM3 │
│ Are you sure you want to PACK (remove deleted records) ? N │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 50
■ RECALL RECORDS
Recalls records previously marked for deletion. This option is identical
to the DELETE RECORDS option discussed earlier...
■ RETURN TO MENU
Returns to the procedure that called MISC Routines.
■ RUN (DOS COMMAND)
Run a DOS command (EG: dir/w). This option is helpful in that it allows
you to run programs at the DOS level (within memory constraints).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN CD\DOS │
└───────────────────────────────────────────────────────────────────────────┘
One useful option is to type and Enter: COMMAND at this prompt. You will
be running another DOS Shell totally out of the program (it still is in
memory though).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN COMMAND │
└───────────────────────────────────────────────────────────────────────────┘
Press and Enter: EXIT to return to your Clipper Application.
KISBILL - Keep It Simple Billing and Invoicing System Page: 51
■ SIMPLE EDITOR
A simple editor and word processor. Use this option to create and read
simple TEXT files. File size is limited to your machines capabilities or
32,000k. The first prompt is for the name of the file you wish to edit. Type
in the name, or press Enter on an empty prompt to bring up a window option
box containing all files in the current directory.
┌────────────────────────┐
┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐
│ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │
│ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │
└────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
│DEMO.MAP │ 7780 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
*** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...),
so be careful at what you select for viewing/editing.
If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE
those changes. If you exit with an Esc, all changes will be lost!
┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐
│CLIPPER demo │
│CLIPPER MISC │
│KWAIT 10 │
│LIB MISC-+MISC,MISC.LST,MISC │
│KWAIT 10 │
│TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │
│KWAIT 10 │
│DEMO │
└────────────────────────────────────────────────────────────────────────────┘
Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0
KISBILL - Keep It Simple Billing and Invoicing System Page: 52
Special keys for 'moving around' the SIMPLE EDITOR screen are:
Left Arrow Key - Move to your left
Right Arrow Key - Move to your right
Ctrl Home - Go to the top, leftmost corner of window
Ctrl End - Go to the bottom, rightmost corner of window
Up Arrow - Move up one line
Down Arrow - Move down one line
PgUp - Page up a full screen
PgDn - Page down a full screen
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end of the file
* F2 - Import text from a text file
* Ctrl W - Save Changes and Exit
* Esc - ABORT Changes and Exit
The margin may exceed the boundaries on the right side of the screen, but
the text is easily accessed using the special keys above...
■ SORT DATABASE
This option takes a database, sorts it, and copies the result into a new
database. The first prompt is for the name of the database you want to sort.
Enter the name, or press Enter on an empty prompt to bring up a window box
containing all databases in the current directory.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DOG.DBF │ 259 │ 09/16/89 │
│CAT.DBF │ 375 │ 09/16/89 │
│CAR.DBF │ 195 │ 09/17/89 │
│BAM.DBF │ 7335 │ 09/16/89 │
│HARP.DBF │ 103 │ 09/17/89 │
│TRAIN.DBF │ 24387 │ 09/17/89 │
│HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└───────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 53
The next prompt is for the name of the database you will be creating with
the sorted data.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: INVNET.DBF │
│ Enter Name of Sorted File: INVNET1.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
The next prompt is for the sort field (limited to 1 field)...
╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: TOM.DBF │
│ Enter Name of Sorted File: TOM1.DBF │
│ Enter the Key Expression: PART │
└───────────────────────────────────────────────────────────────┘
■ TYPE (PRINT) FILE
Prints an ASCII/text file to screen or printer. The first prompt is for
the file name.
┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐
│ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │
│ Press Enter/Return on an empty field to get a current directory listing. │
└────────────────────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 54
The display of the file (any type), is continuous, but can be paused by
any key (except the Enter & Esc keys). Pressing the Enter key will slow the
printing of the file onto the screen. Press Esc to Abort the display... A
sample display:
FUNCKEY...........MISC FUNIQUE...........MISC
FZAP..............MISC GET_PIC1..........MISC
ISDATA............MISC ISDBF.............MISC
MENU_KEY..........MISC MISC..............MISC
OKFILE............MISC PACKIT............MISC
PICKDBF...........MISC PROCLIST..........MISC
SHOW_INS2.........MISC STATLINE2.........MISC
TOG_INS2..........MISC XKEY_CLEAR........MISC
XKEY_NORM.........MISC XMEMO.............MISC
MISC
BKDOOR BROWSEIT CENTER1 COLORSET
DBFUNCT DBFUNCT6 EDITOR FACHOICE
FAPPEND FCOPY2 FDBF1 FDELETE
FERASE FILESZ FILE_UDF FILT
FINDER FINDEX FMAKEDB FMODYDB
FNEW FRECALL FRUN FSCROLL1
FSORT FTYPEIT FUNCKEY FUNIQUE
FZAP GET_PIC1 ISDATA ISDBF
MENU_KEY MISC OKFILE PACKIT
PICKDBF PROCLIST SHOW_INS2 STATLINE2
TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO
PRESS ANY KEY TO CONTINUE...
■ ZAP DATABASE
Totally erase all records in database (forever!). When you want to remove
every record from a database, then use this option. Use with EXTREME CAUTION!
The first prompt is for the file name. Enter the name of the database you are
to 'clean out', or press Enter to select the database from a window
containing all databases in the current directory.
KISBILL - Keep It Simple Billing and Invoicing System Page: 55
┌────┐
│ZAP!│
└────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DENVER.DBF │ 259 │ 09/16/89 │
│OHIO.DBF │ 375 │ 09/16/89 │
│NEWYORK.DBF │ 195 │ 09/17/89 │
│MONTANA.DBF │ 7335 │ 09/16/89 │
│SC.DBF │ 259 │ 09/17/89 │
│EARS.DBF │ 103 │ 09/17/89 │
│FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐
│MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │
│CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │
└──────────────┴────────────┴──────────┘───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
You will be prompted one last time as to whether you still want to ZAP
the selected database. Press Y for Yes, N for No...
┌────┐
│ZAP!│
└────┘
┌──────────────────────────────────────────────────────────────────────────┐
│ ZAP TRASH │
│ Are you sure you want to ZAP (remove all records permanently) ? N │
│ │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 56
■ HELP SCREENS
While in the browse screens, some of the option windows, and in the
SIMPLE EDITOR, pressing the F1 key, will display a help screen.
BROWSE help:
┌───────────────────────[ KISBILL HELP: DBEDIT, 0, ]─────────────────────────┐
│ │
│- Special keys for 'moving around' the BROWSE screen are: │
│ │
│ Left Arrow Key - Move to next field to your left │
│ Right Arrow Key - Move to next field to your right │
│ Ctrl Home - Go to the leftmost field │
│ Ctrl End - Go to the rightmost field (on the end of the record)│
│ Up Arrow - Move highlight to the previous record │
│ Down Arrow - Move highlight to the next record │
│ PgUp - Page up a full screen of records │
│ PgDn - Page down a full screen of records │
│ Ctrl PgUp - Go to the beginning of the file │
│ Ctrl PgDn - Go to the end or last record of the file │
│ Ctrl N - Add a record (where applicable) │
│ Ctrl U - Delete a record (where applicable) │
│ F5,F6,F7 - To seek/find a record based upon the active index │
│ Esc - Exit the current operation │
│ │
│ Remember that there are many more fields to the right of the screen. │
│ Press the right arrow key to view them... │
└────────────────────────────────────────────────────────────────────────────┘
Option Box Help:
┌────────────────────────[ KISBILL HELP: ACHOICE, 0, ]───────────────────────┐
│ │
│ │
│ │
│ │
│ - Special keys for 'moving around' the Option Box are: │
│ │
│ Up Arrow - Move up one option │
│ Down Arrow - Move down one option │
│ PgUp - Page up multiple records │
│ PgDn - Page down multiple records │
│ Esc - ABORT and Exit │
│ │
│ │
│ After highlighting the option you desire, press Enter... │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 57
Editor help:
┌───────────────────────[ KISBILL HELP: MEMOEDIT, 0, ]───────────────────────┐
│ │
│ - Special keys for 'moving around' the EDITOR screen are: │
│ │
│ Left Arrow Key - Move to your left │
│ Right Arrow Key - Move to your right │
│ Ctrl Home - Go to the top, leftmost corner of window │
│ Ctrl End - Go to the bottom, rightmost corner of window │
│ Up Arrow - Move up one line │
│ Down Arrow - Move down one line │
│ PgUp - Page up a full screen │
│ PgDn - Page down a full screen │
│ Ctrl PgUp - Go to the beginning of the file │
│ Ctrl PgDn - Go to the end of the file │
│ Ctrl W - SAVE Changes and Exit │
│ Esc - ABORT Changes and Exit │
│ F2 - Import another text file into your document │
│ │
│ The margin may exceed the boundaries on the right side of the screen, │
│ but the text is easily accessed using the special keys above... │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
■ EXPANDED HELP
After Version 1.3, expanded help routines was added to KISBILL. At almost
all prompts and menus you can press F1 for help. Help can be a function key
message as displayed on previous page or a message that you have created
(user defined & inputted).
KISBILL - Keep It Simple Billing and Invoicing System Page: 58
■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
If you press F1 and no user defined & inputted message exists for that
section of the program you are currently in you will receive a message to
this effect, and then a blank/empty screen.
The editing keys for this option are the same as for the Simple Editor
(previous page).
┌──────[ DAYO HELP Called by Program: KISBILL Variable: OPT ]───────┐
│ │
│ │
│ │
│ │
│ │
│ │
│ ╔════════════════════════════════════════════════════════╗ │
│ ║ No Online Help Messages Exist for this prompt... ║ │
│ ║ ║ │
│ ║ You can type in any help message you wish. ║ │
│ ║ ║ │
│ ║ ║ │
│ ║ ║ │
│ ║ Press any key to continue... ║ │
│ ╚════════════════════════════════════════════════════════╝ │
│ │
│ │
├───────────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │
└───────────────────────────────────────────────────────────────────────────┘
If you wish to input anything at this point, just type whatever you
wish, remembering to press Ctrl W to save all changes. Pressing Esc will
not save ANY changes ( all effort you put into writing a help message will
be lost! ). * * * Press Ctrl W to save your changes!!!! * * *
KISBILL - Keep It Simple Billing and Invoicing System Page: 59
DAYOINV V1.3, TJS LAB ┌────[August 1990]──┐
┌───────[ DAYO HELP Called by Program: KISBILL Variable: OPT ]───────┐
│ │
│ │
│ │
│ │
│ Type in anything you wish about this portion of the program! │
│ │
│ The length of this file can be many pages... │
│ │
│ Be sure to press Ctrl W to save any changes/additions you make to this │
│ screen. │
│ │
│ │
│ │
│ │
│ │
│ │
├────────────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │
└────────────────────────────────────────────────────────────────────────────┘
KISBILL - Keep It Simple Billing and Invoicing System Page: 60
■ DATABASE STRUCTURES
Structure for database: INVOICE.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 ITEM Character 12 1 12
1 INVOICE Numeric 8 1 8
2 NAME Character 30 9 38
3 CUSNUM Numeric 8 39 46
4 ATTN Character 30 47 76
5 ADDRESS1 Character 30 77 106
6 ADDRESS2 Character 30 107 136
7 CITY Character 17 137 153
8 STATE Character 2 154 155
9 ZIP Character 10 156 165
10 PHONE Character 14 166 179
11 TERMS Character 14 180 193
12 DATE Date 8 194 201
13 BY Character 15 202 216
14 CUST_PO Character 15 217 231
15 TAX Logical 1 232 232
16 ADJUST Numeric 10 2 233 242
17 FREIGHT Numeric 10 2 243 252
18 SUBTOTAL Numeric 10 2 253 262
19 OPEN Logical 1 263 263
20 PAID Numeric 10 2 264 273
21 DUE Numeric 10 2 274 283
22 COMMENT Character 50 284 333
23 TAXES Numeric 10 2 334 343
────────── ─────
Total 344
Structure for database: DETAIL.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 ITEM Character 12 1 12
1 INVOICE Numeric 8 1 8
2 ITEM Character 10 9 18
3 DESC Character 30 19 48
4 QTY Numeric 9 3 49 57
5 PRICE Numeric 10 2 58 67
6 DATE Date 8 68 75
────────── ─────
Total 76
KISBILL - Keep It Simple Billing and Invoicing System Page: 61
■ DATA DICTIONARY
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
ADDRESS1 C 30 0 INVOICE.DBF 1st line of the customer's address
ADDRESS2 C 30 0 INVOICE.DBF 2nd line of the customer's address
ADJUST N 10 2 INVOICE.DBF Adjustment value
ATTN C 30 0 INVOICE.DBF Attention/Contact name
BY C 15 0 INVOICE.DBF Name of the user that made the
invoice
CITY C 17 0 INVOICE.DBF City
COMMENT C 50 0 INVOICE.DBF Comment placed onto the invoice
CUSNUM N 8 0 INVOICE.DBF Customer's number
CUST_PO C 15 0 INVOICE.DBF Customer purchase order number
DATE D 8 0 INVOICE.DBF Date invoice was created
DETAIL.DBF
DESC C 30 0 DETAIL.DBF Description of detail item
DUE N 10 2 INVOICE.DBF Amount still due on invoice
FREIGHT N 10 2 INVOICE.DBF Freight value
INVOICE N 8 0 DETAIL.DBF Invoice number
INVOICE.DBF
ITEM C 10 0 DETAIL.DBF Item/Product/Part number
NAME C 30 0 INVOICE.DBF Customer's name
OPEN L 1 0 INVOICE.DBF Flag to denote whether invoice is
open or closed
PAID N 10 2 INVOICE.DBF Amount received from customer as
payment on the invoice
PHONE C 14 0 INVOICE.DBF Customer's telephone number
PRICE N 10 2 DETAIL.DBF Price of an item
QTY N 9 3 DETAIL.DBF Quantity sold per item
STATE C 2 0 INVOICE.DBF State
SUBTOTAL N 10 2 INVOICE.DBF Subtotal of the detail item
( Cost * Quantity)
TAX L 1 0 INVOICE.DBF Flag to denote whether the invoice
is to be taxed
TAXES N 10 2 INVOICE.DBF Amount of taxes charged
TERMS C 14 0 INVOICE.DBF Invoice terms, ie: CASH, CHECK,
NET 30, NET 60, DUE NOW!
ZIP C 10 0 INVOICE.DBF Zip code
KISBILL - Keep It Simple Billing and Invoicing System Page: 62
■ TJS 'Computer' LAB
TJS LAB is an association of programmers and technicians that produce
customized, multiuser software for the PC based network (ie: Novell (tm) and
others). Our specialties include Inventory Control, PC Communications/EDI,
Management, Reports (standard and graphic), Data Conversions, and some
Accounting (A/R, A/P).
A unique feature of TJS LAB is that our software is by default, multiuser.
'Standalone' applications are the exception! All our applications are
written in Clipper, Basic, or C (preferably Basic or Clipper). We will
license all our application source codes. We produce applications that work,
are easy to use, and are inexpensive!
Want a change?
Want an enhancement!
Want a completely new product/application?
Want to make your idea a reality?
Custom/contract programming, by TJS LAB, and our associates is available.
Standard rate is $50.00 per hour (our sites). Guarantees for quality and
timely work is our number one rule ('Do it now and do it right!').
We make program enhancements/changes/fixes at our location(s), but can/do
make 'house calls' via special software and a modem.
Write us at:
TJS LAB
PO Box 585366
Orlando, Florida 32858-5366
Or use our voice mail/answering machine (24 hours/day) *
(407) 291-3960
* Note that TJS LAB, nor any of the associates accept/take any support
calls for unregistered products.
KISBILL - Keep It Simple Billing and Invoicing System Page: 63
ORDER FORM: KISBILL
Keep It Simple Billing & Invoicing System
For the cost of registering/licensing this software, you will
receive the latest version of this program without any logos or delays
screens. You will also be notified of upgrades and of other TJS LAB products!
A Source Code License is available. KISBILL is written with Nantucket's
Clipper (dBase (tm) compiler), using the Funcky library by dLESKO Associates.
A Source Code License means you have the right to use & modify the source
codes for your personal/business/network needs, but no rights to resell any
part of it without the prior written consent of TJS LAB.
COST QTY
------ -----
KISBILL Registration ............................... $50.00 _____
KISBILL Source Code License ........................$405.00 _____
(The Source Code License includes the registration fee)
Shipping & Handling ................................. $5.00 _____
TOTAL: __________
┌───────────────────────────────────┐
Check or Money Order Only Please. │ Note: The Registration Copy will │
--------------------------------- │ be mailed to you on a 5.25 floppy │
│ unless otherwise specified... │
└───────────────────────────────────┘
Print Your Name and Address
Clearly...
Mail To:
Name: _______________________________
TJS LAB
Address: _______________________________ Attn: KIS SALES
PO BOX 585366
_______________________________ Orlando, Florida 32858-5366
_______________________________
*** Check out KISBILL's big
_______________________________ sister -> DAYO!
Any Special Instructions/Comments? (Please!)
____________________________________________________________________________
____________________________________________________________________________
